USE NutritionTracker
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'AppRole') AND type in (N'U'))
	DROP TABLE AppRole
GO
CREATE TABLE	AppRole
(
	AppRoleID	TINYINT IDENTITY(1,1) NOT NULL,
	AppRoleName		NVARCHAR(50) NOT NULL UNIQUE NONCLUSTERED,
	Deleted		BIT NOT NULL CONSTRAINT df_AppRole_Deleted DEFAULT 0,
	CONSTRAINT pk_AppRole PRIMARY KEY(AppRoleID ASC)
)
GO
